JHawks8221
New Member
- Joined
- May 12, 2017
- Messages
- 9
- Office Version
- 365
Hello. I'm sorry I know this may be a simple problem, but I'm having difficulties trying to work this out. I need a formula on an excel spreadsheet that will count the number of complaints for certain products for each month (IE in the example image below, How many apple complaints we've had for January, and then in February
For Example:
I've tried SUMPRODUCT, and a combination of a IF/COUNTIF/SUMPRODUCT formula (Example I found from GOOGLE that I've tried to play around with but couldn't make work: '=IF(COUNTIF($A$309:$A$606,"ABC"),SUMPRODUCT(H309:H606,P309:P606),"")
I know this has to be something simple I'm missing. Would anyone be able to help me out with this please? I've tried searching on google but have been struggling to find an answer on how to calculate this (I'm not very good with formulas honestly)
Thank-you very much!
For Example:
I've tried SUMPRODUCT, and a combination of a IF/COUNTIF/SUMPRODUCT formula (Example I found from GOOGLE that I've tried to play around with but couldn't make work: '=IF(COUNTIF($A$309:$A$606,"ABC"),SUMPRODUCT(H309:H606,P309:P606),"")
I know this has to be something simple I'm missing. Would anyone be able to help me out with this please? I've tried searching on google but have been struggling to find an answer on how to calculate this (I'm not very good with formulas honestly)
Thank-you very much!