View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default

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.