IF

S

Shannan

Column CZ in my spreadsheet calculates the difference between two dates in
months. I would like to put a formula at the bottom of this column that tells
it to total all of the cells from CZ5 to CZ999 that show a value lesser than
or equal to 3. What kind of formula can i use?
 
×

מיכ×ל (מיקי) ×בידן

Try SUMIF (or COUNTIF if I misunderstood you)
*** you will find explanations in Excels Help ***
Micky
 

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

Expanding Date formula 1
if formula 1
Excel Sumproduct 0
Calculate Age 5
Dependent "If" formulas 2
Using SUMIFS with date range 4
Excel Help with dates 2
Scrabble Value calculation for Welsh words 0

Top