M
mark petrak
i have a spreadsheet im working on, but i want it to do somthing i dont
know if it can do. here is my problem
A B C H
1 A1 B1 C1 H1
2 A2 B2 C2
3 A3 B3 C3
4 A4 B4 C4
5 A5 B5 C5
so i want H1 to = a range 0f data. i want it to look in column A for
certain criteria, and if that row in column A meets the criteria it
takes that same rows column C value and adds them together. so if it
were to be a logical test it would be somthing like this
if A1:A5= A2,A4,A5. then take the sum of C2,C4,C5. and put it in H1
let me know if you guys understand what im looking for.
Thanks
know if it can do. here is my problem
A B C H
1 A1 B1 C1 H1
2 A2 B2 C2
3 A3 B3 C3
4 A4 B4 C4
5 A5 B5 C5
so i want H1 to = a range 0f data. i want it to look in column A for
certain criteria, and if that row in column A meets the criteria it
takes that same rows column C value and adds them together. so if it
were to be a logical test it would be somthing like this
if A1:A5= A2,A4,A5. then take the sum of C2,C4,C5. and put it in H1
let me know if you guys understand what im looking for.
Thanks