adding more coloums to sum if

[Charlene Durand]

=SUMIF(table[[#All],[Date]],"="&B4,table[[#All],[CRG HRS]])

i now need to add the following which is right next to each other. (this is a pivital table

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]

CRG HRS​

[/TD]
[TD="align: center"]Sick[/TD]
[TD="align: center"]Annual[/TD]
[TD="align: center"]PPH[/TD]
[/TR]
</tbody>[/TABLE]

 

[WAYNE_TAI]

Do you mean multiple criteria? try SUMIFS?

 

[Charlene Durand]

Correct should it look like this.

=SUMIFs(table[[#All],[Date]],"="&B4,table[[#All],[CRG HRS],[Sick],[Annual],[PPH]]]]])

it keeps on showing me an error on the bold section: =SUMIFs(table[[#All],[Date]],"="&B4,table[[#All],[CRG HRS],[Sick],[Annual],[PPH]]]]])

 

[WAYNE_TAI]

Are you trying to merge the texts in the 4 columns if it fulfills a certain criteria?

 

[Charlene Durand]

That is correct i am using this formula in my time tracking sheet so i have four diffrent criterias for working therefore when i put in my time traking something like a puplic holiday it but add.

How do i send a screen shot