Question

Locked

Excel sumif formula problemb

By confusedexcelman ·
Tags: Software
Hello. I need an excel formula that will count only the cells that contain a specific text string, and match it with only the cells for a particular month and then sum the amounts, and display the results in another column. Here's exactly what I'm trying to do:

COUNT IF b:b is "PA WINE SPIRITS", AND A:A IS ANY REFERENCE TO THE MONTH OF NOVEMBER, THEN
SUM THE AMOUNTS THAT MATCH THAT CRITERIA IN d:d, otherwise don't count or sum.

I can upload the spreadsheet that I have already created without the particular formula I am looking for, except I can't figure out how to upload it here. Anyone know an answer?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums