Count formula (need help)
Solved/Closed
dkayeh1
Posts
24
Registration date
Monday November 2, 2015
Status
Member
Last seen
December 4, 2015
-
Nov 4, 2015 at 03:49 PM
RayH - Nov 4, 2015 at 04:45 PM
RayH - Nov 4, 2015 at 04:45 PM
Related:
- Count formula (need help)
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
Can you explain what it is you are trying to achieve with that formula?
It looks like you are trying to add up all the cells that contain "1" in them. Is that right?
Is this related to your previous question where if the cell is a date then you want to see "1" returned? Ifs so, simply summing that range of cells should give you what you need.
e.g
=SUMIF(O2:O9,">0")
or
=SUM(O2,O5,O8,O10)
It looks like you are trying to add up all the cells that contain "1" in them. Is that right?
Is this related to your previous question where if the cell is a date then you want to see "1" returned? Ifs so, simply summing that range of cells should give you what you need.
e.g
=SUMIF(O2:O9,">0")
or
=SUM(O2,O5,O8,O10)