3 criteria sum

Status
Not open for further replies.

Peter100

Well-known Member
Joined
Apr 21, 2002
Messages
765
Forgive my previous topic, I was in a hurry and misled

I have 3 columns of data
column A contains dates in the format mmm/yy
column B contains a text entry ie purchases
column C contains monetary amounts ie £300.67

I have 2 dates in cell F1 & G1

I want to sum the figures in column C if the entry in column A is equal to or between two values in F1 and G1 and the text entry in column B =purchases

How do I get sumproduct to do this ? :cry:
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,222
Messages
5,570,969
Members
412,352
Latest member
Radek Z
Top