Thank you so much!!! Could I beg you to help with another?

Col C Col E Col G
VA3 LAN 1
V4P V4P 2
V4P LNS 3

I need to get it to look at both Col C & Col E and, if the criteria matches,
total G (in the example, the sum would be 5). The criteria being V4P in Col
C and V4P OR LNS in Col E. I can get it to work for one or the other
SUMPRODUCT((C1:C3="V4P")*(E1:E3="???"),(G1:G3)) where ??? is either V4P or
LNS but I cannot get it to look for both and total it.


"Domenic" wrote:

In article ,
"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A4=--"2004-01-12"),--(A1:A4<=--"2004-01-31"),B1:B4)

with no nasty +0, and internationally standard dates :-)

Actually, for some reason, I find +0 more appealing to the eyes. Just a
personal preference. :)

And, yes, good point about using internationally standard dates. Should
eliminate any confusion.