Test for multiple conditions and then sum

Hi guys, i've already posted a similar question, but i just need to expand on it slightly. My excel formulae is nowhere near as good as my VB is so please treat me like a n00b.

i need a formula to test for conditions within two seperate ranges, and then if said conditions are met, then to return and Sum() a value from another field

eg:
if i had a sheet with three fields, "month", "day" and "value" i want the formula to sum() all results from the "value" field where the corresponding fields month="jan" and day="sat"

the vaule of "value" is a real number

Thanks in advance

:D

Hi,

Quite a few options here. I think your best bet will be the SUMPRODUCT function - check it out in your Excel Helpfile.

The array formula tutorial (http://www.xtremevbtalk.com/showthread.php?t=296012) covers exactly this topic! ;)

Post back if you get stuck!

Colin