Sumif based on value in cell

J

Jane

I am trying to add values in one column, if the second column matches the
criteria. This is what I have written and I know this is wrong. Can anyone
please help.

SUMIF(B:B,"<=AC10 and >=AD10",C:C)

Thank you
 
J

Jane

Thank you Fred.

This is what I have and the result I get is 0, which is not correct. Do you
know what I am doing wrong.


SUMPRODUCT((B8:B152<=AD10),(B8:B152>=AC10),C8:C152)


Thanks again
 
F

Fred Smith

I don't see Mike's post, but from mine you'll notice dashes (--) in my
formula which aren't in yours. It's a simple matter of not copying the
formula properly.

Regards,
Fred.
 

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 based on criteria on another cell 3
SUMIF with criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
evnet code, checking for entry 3
Sumif apllying to all sheets in workbook 2
SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value 3
=sumif function 1
use month in cell date to sum all relevant cells 2

Top