"criteria" in a sumif refering to the value in another cell

G

Guest

I'm trying to do a sumif with the "criteria" refering to an adjacent cell
rather than having the criteria hard keyed into the formula. For example, if
I have a list of purchases by date and I want to sum up those that occured
prior to 12/31/04, and 12/31/04 is the value in another cell. Can i have the
sumif refer to that cell for the "criteria"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF CRITERIA PROBLEM 8
SUMIF Function 1
SUMIF using 2 cells that equal each other 1
SUMIF - pointing to another cell for criteria 3
a "SUMIF" question 1
Where to put quotes in a SUMIF formula and when is & used for cell 2
Using SUMIF and AND functions simultaneously 3
SUMIF - how to enter a second criteria 1

Top