Two columns of data. Column A = PRODUCT TYPE, COLUMN E = Region
I have a spreadsheet that needs to calculate how many "Onions" (in column A) were sold in say "South West" (in Column E).
I thought I could use....
=SUMPRODUCT(A:A="Onions")*(E:E="South West")
but that does not work.
I then tried .....
{=COUNT(IF(A:A="Onions"),IF(E:E="South West))}
but that failed too.
Any ideas? Thanks.
I have a spreadsheet that needs to calculate how many "Onions" (in column A) were sold in say "South West" (in Column E).
I thought I could use....
=SUMPRODUCT(A:A="Onions")*(E:E="South West")
but that does not work.
I then tried .....
{=COUNT(IF(A:A="Onions"),IF(E:E="South West))}
but that failed too.
Any ideas? Thanks.