SUMPRODUCT?

[KENNY]

Hi All:

In the table below, I would like to be able to sum the
revenue from all sites, for the month of January. Help?!

Column:
A B C

Site A: Month January
Units 1
Revenue $100

Site B: Month July
Units 5
Revenue $600


Site C: Month January
Units 3
Revenue $500

 

[Frank Kabel]

Hi
any chance to change this layout as this would be a little bit
difficult to create a formula. Better would be something like
A B C D
1 Site Month Units Revenue
2 Site A January 1 100
3 Site B July 5 600
....


then you would be able to use:
=SUMIF(B1:B100´,"January",D1:d100)

 

[KENNY]

Unfortunately, no.

-----Original Message-----
Hi
any chance to change this layout as this would be a little bit
difficult to create a formula. Better would be something like
A B C D
1 Site Month Units Revenue
2 Site A January 1 100
3 Site B July 5 600
....


then you would be able to use:
=SUMIF(B1:B100´,"January",D1:d100)

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
not tested but try:
=SUMPRODUCT(--(B1:B100="Month"),--(C1:C100="January"),--(B3:B102="Reven
ue"),C3:C102)

--
Regards
Frank Kabel
Frankfurt, Germany

Unfortunately, no.

 

[KENNY]

Thanks for the reply... Unfortunately, it didn't work
(may be user error)

 

[KENNY]

It was user error! Thanks for this and all your other
responses.

 

[Frank Kabel]

Hi
glad you sorted it out )

--
Regards
Frank Kabel
Frankfurt, Germany

It was user error! Thanks for this and all your other
responses.

 

[Aladin Akyurek]

Does

=SUMPRODUCT(--($C$1:$C$9="january"),$C$3:$C$11)

work as intended?

Unfortunately, no.