Hi Guys,
Appologies if i sound quite inexperienced but I am wondering if any of you could help me with this request.
REFER TO THE ATTACHED SPREADSHEET.
Basically, I would like a excel formula that would:
a) Select Customer 'John' from Column A
b) Select Product Type 'Sugar' from Column B
.. to produce a count output of how many times this would occur.
I have extensive amount of data that I need to count but I seem to be having trouble with this as I have been mixing around with COUNTIF statements which all but seem to fail.
Any help we would be greatly appreciated.
Cheers,
Daniel
Bookmarks