Urgent help needed with a SUMIF formula

[Michael]

Hi,
Whether or not this is possible I dont know, but I'm
trying to specify a choice of values in the "Criteria"
area of the function.

E.G. - SUMIF(A1:A20,August"OR"September,B1:B20) - The "OR"
being my objective for excel to recognise either August or
September.

This is a simplified version of what I'm doing, but if
anyone could let me know how to express this as an
acceptable formula, or confirm that it is impossible, it
would be appreciated beyond belief!

Thanks in advance.

P.S. - I have been cursed with having to use Excel 97 to
complete this exercise.

 

[Paul Corrado]

Michael,

SUMIF(A1:A20,"August",B1:B20)+SUMIF(A1:A20,"September",B1:B20)

PC

 

[Don Guillett]

try
=sumproduct((a1:a20={"August","September"})*b1:b20)

 

[Michael]

Hi Paul,
Thanks for the message. Unfortunately because I am doing
so many of these in each cell, Excel is preventing from
increasing the size of my formula to accomodate two SUMIF
functions. Is there any way you know of shortening the
formula, but still checking for both August & September.
Thanks,
Michael