ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sum if formula (https://www.excelbanter.com/excel-discussion-misc-queries/264387-sum-if-formula.html)

sum if
sum if formula
 
=SUM(IF('Day 1'!$C$4:$C$37=A22,'Day 1'!$D$4:$M$37))+SUM(IF('Day
2'!$C$4:$C$37=A22,'Day 2'!$D$4:$M$37))+SUM(IF('Day 3'!$C$4:$C$37=A22,'Day
3'!$D$4:$M$37))+SUM(IF('Day 4'!$C$4:$C$37=A22,'Day
4'!$D$4:$M$37))+SUM(IF('Day 5'!$C$4:$C$37=A22,'Day
5'!$D$4:$M$37))+SUM(IF('Day 6'!$C$4:$C$37=A22,'Day
6'!$D$4:$M$37))+SUM(IF('Day 7'!$C$4:$C$37=A22,'Day
7'!$D$4:$M$37))+SUM(IF('Day 8'!$C$4:$C$37=A22,'Day
8'!$D$4:$M$37))+SUM(IF('Day 9'!$C$4:$C$37=A22,'Day
9'!$D$4:$M$37))+SUM(IF('Day 10'!$C$4:$C$37=A22,'Day
10'!$D$4:$M$37))+SUM(IF('Day 11'!$C$4:$C$37=A22,'Day
11'!$D$4:$M$37))+SUM(IF('Day 12'!$C$4:$C$37=A22,'Day
12'!$D$4:$M$37))+SUM(IF('Day 13'!$C$4:$C$37=A22,'Day
13'!$D$4:$M$37))+SUM(IF('Day 14'!$C$4:$C$37=A22,'Day
14'!$D$4:$M$37))+SUM(IF('Day 15'!$C$4:$C$37=A22,'Day
15'!$D$4:$N$37))+SUM(IF('Day 16'!$C$4:$C$37=A22,'Day
16'!$D$4:$M$37))+SUM(IF('Day 17'!$C$4:$C$37=A22,'Day
17'!$D$4:$M$37))+SUM(IF('Day 18'!$C$4:$C$37=A22,'Day
18'!$D$4:$M$37))+SUM(IF('Day 19'!$C$4:$C$37=A22,'Day
19'!$D$4:$M$37))+SUM(IF('Day 20'!$C$4:$C$37=A22,'Day
20'!$D$4:$M$37))+SUM(IF('Day 21'!$C$4:$C$37=A22,'Day
21'!$D$4:$M$37))+SUM(IF('Day 22'!$C$4:$C$37=A22,'Day
22'!$D$4:$M$37))+SUM(IF('Day 23'!$C$4:$C$37=A22,'Day
23'!$D$4:$M$37))+SUM(IF('Day 24'!$C$4:$C$37=A22,'Day
24'!$D$4:$M$37))+SUM(IF('Day 25'!$C$4:$C$37=A22,'Day
25'!$D$4:$M$37))+SUM(IF('Day 26'!$C$4:$C$37=A22,'Day
26'!$D$4:$M$37))+SUM(IF('Day 27'!$C$4:$C$37=A22,'Day
27'!$D$4:$M$37))+SUM(IF('Day 28'!$C$4:$C$37=A22,'Day
28'!$D$4:$M$37))+SUM(IF('Day 29'!$C$4:$C$37=A22,'Day
29'!$D$4:$M$37))+SUM(IF('Day 30'!$C$4:$C$37=A22,'Day
30'!$D$4:$M$37))+SUM(IF('Day 31'!$C$4:$C$37=A22,'Day 31'!$D$4:$M$37))

Teethless mama
sum if formula
 
What is your question?


"sum if" wrote:

=SUM(IF('Day 1'!$C$4:$C$37=A22,'Day 1'!$D$4:$M$37))+SUM(IF('Day
2'!$C$4:$C$37=A22,'Day 2'!$D$4:$M$37))+SUM(IF('Day 3'!$C$4:$C$37=A22,'Day
3'!$D$4:$M$37))+SUM(IF('Day 4'!$C$4:$C$37=A22,'Day
4'!$D$4:$M$37))+SUM(IF('Day 5'!$C$4:$C$37=A22,'Day
5'!$D$4:$M$37))+SUM(IF('Day 6'!$C$4:$C$37=A22,'Day
6'!$D$4:$M$37))+SUM(IF('Day 7'!$C$4:$C$37=A22,'Day
7'!$D$4:$M$37))+SUM(IF('Day 8'!$C$4:$C$37=A22,'Day
8'!$D$4:$M$37))+SUM(IF('Day 9'!$C$4:$C$37=A22,'Day
9'!$D$4:$M$37))+SUM(IF('Day 10'!$C$4:$C$37=A22,'Day
10'!$D$4:$M$37))+SUM(IF('Day 11'!$C$4:$C$37=A22,'Day
11'!$D$4:$M$37))+SUM(IF('Day 12'!$C$4:$C$37=A22,'Day
12'!$D$4:$M$37))+SUM(IF('Day 13'!$C$4:$C$37=A22,'Day
13'!$D$4:$M$37))+SUM(IF('Day 14'!$C$4:$C$37=A22,'Day
14'!$D$4:$M$37))+SUM(IF('Day 15'!$C$4:$C$37=A22,'Day
15'!$D$4:$N$37))+SUM(IF('Day 16'!$C$4:$C$37=A22,'Day
16'!$D$4:$M$37))+SUM(IF('Day 17'!$C$4:$C$37=A22,'Day
17'!$D$4:$M$37))+SUM(IF('Day 18'!$C$4:$C$37=A22,'Day
18'!$D$4:$M$37))+SUM(IF('Day 19'!$C$4:$C$37=A22,'Day
19'!$D$4:$M$37))+SUM(IF('Day 20'!$C$4:$C$37=A22,'Day
20'!$D$4:$M$37))+SUM(IF('Day 21'!$C$4:$C$37=A22,'Day
21'!$D$4:$M$37))+SUM(IF('Day 22'!$C$4:$C$37=A22,'Day
22'!$D$4:$M$37))+SUM(IF('Day 23'!$C$4:$C$37=A22,'Day
23'!$D$4:$M$37))+SUM(IF('Day 24'!$C$4:$C$37=A22,'Day
24'!$D$4:$M$37))+SUM(IF('Day 25'!$C$4:$C$37=A22,'Day
25'!$D$4:$M$37))+SUM(IF('Day 26'!$C$4:$C$37=A22,'Day
26'!$D$4:$M$37))+SUM(IF('Day 27'!$C$4:$C$37=A22,'Day
27'!$D$4:$M$37))+SUM(IF('Day 28'!$C$4:$C$37=A22,'Day
28'!$D$4:$M$37))+SUM(IF('Day 29'!$C$4:$C$37=A22,'Day
29'!$D$4:$M$37))+SUM(IF('Day 30'!$C$4:$C$37=A22,'Day
30'!$D$4:$M$37))+SUM(IF('Day 31'!$C$4:$C$37=A22,'Day 31'!$D$4:$M$37))

mojohn
sum if formula
 
I am getting the error #value!

I am trying do an if formula that if a user choose from a dropdown list

example:

list:
a1 = mary
a2 = bobbie
a3 = john

=sum(if('sheet 2'!a1:A10 =a1, 'sheet 1'!b1:d10)+=sum(if('sheet 3'!a1:A10
=a1, 'sheet 3'!b1:d10)


on sheet one it should give totals but I am getting the error #value!



--
Mo John


"Teethless mama" wrote:

What is your question?


"sum if" wrote:

=SUM(IF('Day 1'!$C$4:$C$37=A22,'Day 1'!$D$4:$M$37))+SUM(IF('Day
2'!$C$4:$C$37=A22,'Day 2'!$D$4:$M$37))+SUM(IF('Day 3'!$C$4:$C$37=A22,'Day
3'!$D$4:$M$37))+SUM(IF('Day 4'!$C$4:$C$37=A22,'Day
4'!$D$4:$M$37))+SUM(IF('Day 5'!$C$4:$C$37=A22,'Day
5'!$D$4:$M$37))+SUM(IF('Day 6'!$C$4:$C$37=A22,'Day
6'!$D$4:$M$37))+SUM(IF('Day 7'!$C$4:$C$37=A22,'Day
7'!$D$4:$M$37))+SUM(IF('Day 8'!$C$4:$C$37=A22,'Day
8'!$D$4:$M$37))+SUM(IF('Day 9'!$C$4:$C$37=A22,'Day
9'!$D$4:$M$37))+SUM(IF('Day 10'!$C$4:$C$37=A22,'Day
10'!$D$4:$M$37))+SUM(IF('Day 11'!$C$4:$C$37=A22,'Day
11'!$D$4:$M$37))+SUM(IF('Day 12'!$C$4:$C$37=A22,'Day
12'!$D$4:$M$37))+SUM(IF('Day 13'!$C$4:$C$37=A22,'Day
13'!$D$4:$M$37))+SUM(IF('Day 14'!$C$4:$C$37=A22,'Day
14'!$D$4:$M$37))+SUM(IF('Day 15'!$C$4:$C$37=A22,'Day
15'!$D$4:$N$37))+SUM(IF('Day 16'!$C$4:$C$37=A22,'Day
16'!$D$4:$M$37))+SUM(IF('Day 17'!$C$4:$C$37=A22,'Day
17'!$D$4:$M$37))+SUM(IF('Day 18'!$C$4:$C$37=A22,'Day
18'!$D$4:$M$37))+SUM(IF('Day 19'!$C$4:$C$37=A22,'Day
19'!$D$4:$M$37))+SUM(IF('Day 20'!$C$4:$C$37=A22,'Day
20'!$D$4:$M$37))+SUM(IF('Day 21'!$C$4:$C$37=A22,'Day
21'!$D$4:$M$37))+SUM(IF('Day 22'!$C$4:$C$37=A22,'Day
22'!$D$4:$M$37))+SUM(IF('Day 23'!$C$4:$C$37=A22,'Day
23'!$D$4:$M$37))+SUM(IF('Day 24'!$C$4:$C$37=A22,'Day
24'!$D$4:$M$37))+SUM(IF('Day 25'!$C$4:$C$37=A22,'Day
25'!$D$4:$M$37))+SUM(IF('Day 26'!$C$4:$C$37=A22,'Day
26'!$D$4:$M$37))+SUM(IF('Day 27'!$C$4:$C$37=A22,'Day
27'!$D$4:$M$37))+SUM(IF('Day 28'!$C$4:$C$37=A22,'Day
28'!$D$4:$M$37))+SUM(IF('Day 29'!$C$4:$C$37=A22,'Day
29'!$D$4:$M$37))+SUM(IF('Day 30'!$C$4:$C$37=A22,'Day
30'!$D$4:$M$37))+SUM(IF('Day 31'!$C$4:$C$37=A22,'Day 31'!$D$4:$M$37))


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com