Ok, I'm trying to do a simple sumif, and getting a result of zero which is incorrect
for example : =SUMIF('QO'!F8:F1000,"*May*",'QO'!E8:E1000)
F8:f1000 is formatted as ddd dd mmm
E8:e100o is formatted as Number
Any ideas ?
thanks
Ok, I'm trying to do a simple sumif, and getting a result of zero which is incorrect
for example : =SUMIF('QO'!F8:F1000,"*May*",'QO'!E8:E1000)
F8:f1000 is formatted as ddd dd mmm
E8:e100o is formatted as Number
Any ideas ?
thanks
Try with Sumproduct:
=SUMPRODUCT((TEXT('QO'!F8:F1000,"mmm")="May")*'QO'!E8:E1000)
Quang PT
Try This
IF YOUR SHEET LIKE
E8:E1000 = WHERE FROM YOU SUM
F8:F1000 = RANGE FOR MATCH
THEN
=SUMIFS(E8:E1000,F8:F10000,">="&5/1/2015,F8:F10000,"<="&5/31/2015)
bebo021999
IS ALSO RIGHT.
Choose which is easy for you.
If you have got your solution then Mark this thread as solved.
And add reputation
It doesn't matter how cells are formatted, what matters is what's in the cell. If column F does contain proper date numbers then maybe
Formula:Please Login or Register to view this content.
Rather than hard code the date yoo may prefer to put say 1/5/2014 in a cell named "MyDate" and then use
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Than you all for the quick response.
I have used the formula from bebo, which is working fine. thank you.
This is a slightly different with the criteria for the dates:
Formula:Please Login or Register to view this content.
or using cell references with the dates in J7 and K7
)Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks