Hi!
Try this:
=SUMPRODUCT((G3:G10={"Jul","Aug","Sep"})*H3:H10)
Biff
"FrankTimJr" wrote in message
...
I couldn't find the answer in this newsgroup...Is it possible to get the
Sumif statement to calcluate against three different criteria w/out
creating
multiple sumif statements?
Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)?
I know using the comma's in between the Months, but is there some other
way
to get this working? I can't use or < because the Month's are text
only.
|