pick a column based on more than 1 column heading

[ashisha155]

Dear Chandoo


I have a range with multiple columns with two headings, pls advise me how to pick up a column based on two conditions for the two column headings

https://www.dropbox.com/s/kdla8062fvbfuy3/Book1.xlsx


From the above table I wanna calculate the sum of a brand for a month for the Dispatch (with formulas and not VBA)

 

[SirJB7]

Hi, ashisha155!


Welcome back after a long time.


Try this:

=SUMAPRODUCTO((C3:J14)*(A3:A14="Brand A")*(C2:J2="Dispatch")) -----> in english: =SUMPRODUCT((C3:J14)*(A3:A14="Brand A")*(C2:J2="Dispatch"))

for "Brand A" and "Dispatch" example.


Regards!