PDA

View Full Version : sumif functionality

comf36
09-21-03, 21:06
trying to sum a range of cells by dates without using the cell number.

here's my example, please advised

=sumif($07/01/2003$:$07/31/2003$,"salescount", $cost$) getting an error.
sathyaram_s
09-22-03, 04:17
getting an error ....

But what does the error message say ?

Cheers
Sathyaram
Originally posted by comf36
trying to sum a range of cells by dates without using the cell number.

here's my example, please advised

=sumif($07/01/2003$:$07/31/2003$,"salescount", $cost$) getting an error.
comf36
09-23-03, 23:00
=SUMIF(A2:A50,"=INVENTORYTIMES",G2:G50

the results are 0:00 because their cycle times. I would like it to pull by dates not cell numbers, the spreadsheet is update bi-weekly separate by ranges. Cells G2:G50 are total times and I would like to sum them by dates not cells, like A2:A50
comf36
09-24-03, 00:53
=SUM(IF("#07/01/03#,#07/31/03#","INVENTORYTIMES",G1)