Hi Scott
not actually sure what the criteria is here ... or what you're after
do you want the sum all the values together that are to the left of a 5 or a
7
or do you want to sum the first column if the second column is either a 5 or
7?
or do you want to sum the numbers in column A if B is a 5, in C if D is a 5,
E if F is a 7 and G if H is a 7
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Scott Powell" <Scott
wrote in message
...
I'm trying to sum the number in one column based on criteria in another
column, but there are also multiple columns on the spreadsheet.
1 5 2 5 1.5 7 2 7
If the second number is a 5, I want the sum of the first numbers.
Likewise
for the 7.
Thanks,
Scott